Hi List

Many thanks to Pieter Geert van den Beukel, Ianko Tchoukanski, Bryan Hill, Oliver Raskop, Bent Hermannsen, Peg Heaney, Robin Poole, Rey de Castro, Gary M. Greenberg, Gary Adams, David Billy, Marcus Cole, Mike Lent, Scott Engel, Amy Lang, Brain Beckenbaugh, David van Riel, Ianko Tchoukanski, Elwyn McLachlan and Stewart Edwardes
----------------------------------------------
My original post:

Hello lister,

Have anyone had experience in Aveune to "trim" a string using char positions (ie: giving a string, 2 numbers and it will return a string which the given number of characters were trimmed from the left and from the right)

 Example: Input: ABCDEFG,2,2
           Return: CDE

Does Avenue has the ability to do the so?  I know that there is a function: AString.BasicTrim leftchars,rightchars) However, it will only work if the content of that string is known.
-------------------------------------------------------
Solutions:

1.
StrInput = “abcdefgh”
StrCount = StrInput.Count

NumLeft = 2
NumRight = 2

StrOutput = StrInput.Middle(numleft, StrCount – numRight - numLeft)

This will always lop off the first # of characters and the last # of characters.
-------------------------------------------------------
2.
Field Calculator
-------------------------------------------------------3.
You could try STRING.ASLIST then remove the characters as you want MyList.get(2) and MyList.get(3)….you could then concentrate these new string, a bit of a work around I know.  Hope it helps


Thanks again,

Carl Chan


__________________________________________________________
Get your FREE personalized e-mail at http://www.canada.com